$anzahl = $db_zugriff->query_first("SELECT COUNT(userid)as anzahl FROM bb".$n."_user_table WHERE activation='1'");
$anzahl = $anzahl[anzahl];
$page=intval($page);
if(!$page) $page=1;
switch($by) {
case "username"; break;
case "regdate": break;
default: $by = "userposts"; break;
}
switch($order) {
case "ASC"; break;
default: $order = "DESC"; break;
}
$user_result = $db_zugriff->query("SELECT * FROM bb".$n."_user_table WHERE activation='1' ORDER by $by $order LIMIT ".($uproseite*($page-1)).",".$uproseite);
$user_info = $db_zugriff->query_first("SELECT users.*, avatars.extension FROM bb".$n."_user_table users LEFT JOIN bb".$n."_avatars avatars ON (avatars.id=users.avatarid) WHERE users.userid='$userid'");
$rank = $db_zugriff->query_first("SELECT * FROM bb".$n."_ranks WHERE groupid = '$user_info[groupid]' AND posts<='$user_info[userposts]' ORDER by posts DESC");